 CREATE EXTERNAL TABLE jms_ods.tab_barscan_sign_hi(
   `billcode` string COMMENT '运单编号',
   `delivertime` timestamp COMMENT '派送时间',
   `receipttype` string COMMENT '回单类型',
   `deliveruser` string COMMENT '派件员',
   `signuser` string COMMENT '签收人',
   `signedstatus` string COMMENT '派送状态',
   `inputuser` string COMMENT '录人员',
   `inputtime` timestamp COMMENT '录入时间',
   `remark` string COMMENT '备注',
   `inputsite` string COMMENT '录入网点',
   `deliverfee` double COMMENT '派件费',
   `freightcollect` double COMMENT '到付款',
   `sendstation` string COMMENT '寄件站',
   `destination` string COMMENT '目的地',
   `realweight` double COMMENT '实际重量',
   `cod` double COMMENT '代收款',
   `fctomonth` string COMMENT '到付转月结',
   `fccurrency` string COMMENT '到付款币别',
   `deliverfeecurrency` string COMMENT '派件费币别',
   `codcurrency` string COMMENT '代收款币别',
   `codflag` string COMMENT '代收款已收',
   `sendsite` string COMMENT '寄件网点',
   `destsite` string COMMENT '目的网点',
   `senddate` timestamp COMMENT '寄件日期',
   `recepitsigned` string COMMENT '货单已签',
   `siteaccountflag` string COMMENT '网点对帐标识',
   `fcmonthlyaccount` string COMMENT '到付款月结帐号',
   `transferflag` string COMMENT '传输标识',
   `transfertime` timestamp COMMENT '传输时间',
   `transferuser` string COMMENT '传输人',
   `commision` double COMMENT '提成金额',
   `inputtype` string COMMENT '录入类型',
   `modifystatus` string COMMENT '编辑状态',
   `currency` string COMMENT '币别',
   `collecttype` string COMMENT '收款类型',
   `shifts` string COMMENT '班次',
   `commisionremark` string COMMENT '提成备注',
   `pcs` double COMMENT '件数',
   `chargedweight` double COMMENT '计费重量',
   `contractarea` string COMMENT '派件承包区',
   `agentflag` string COMMENT '代理标识',
   `scansitecode` string COMMENT '扫描网点编号',
   `uploadtime` timestamp COMMENT '上传时间',
   `remark3` string COMMENT '备注3',
   `scanusercode` string COMMENT '扫描雇员编号',
   `send_deliver_usercode` string COMMENT '收派员编号',
   `nextstationcode` string COMMENT '上下一站编号',
   `source` string COMMENT '来源',
   `remark5` string COMMENT '备注5',
   `remark6` double COMMENT '备注6',
   `remark4` string COMMENT '备注4',
   `scansiteid` bigint COMMENT '扫描网点ID',
   `nextstationid` bigint COMMENT '上一站/下一站ID',
   `scanuserid` bigint COMMENT '扫描雇员ID',
   `send_deliver_userid` bigint COMMENT '收派员ID')
 COMMENT '签收表'
 PARTITIONED BY (
   `dt` string COMMENT '更新日期 (yyyy-MM-dd HH)')
 ROW FORMAT SERDE
   'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
 STORED AS INPUTFORMAT
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
 OUTPUTFORMAT
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
 LOCATION
   '/dw/hive/jms_ods.db/external/tab_barscan_sign_hi'
